Previous Topic

Next Topic

Example: Find recipients for e-mail

This query extracts the recipient list for an e-mail notification.

  1. Browse to IQA.
  2. Select Query from the drop-down list and select New.
  3. Select New.
  4. Select the sources:
    1. Browse to the Common folder containing business objects.
    2. Select CsContact.
  5. Define the filtering rules:
    1. Select the Filters tab.
      • Mode: Basic
      • Property: Email
      • Comparison: Not Empty
    2. Add the filter.
  6. Define the columns to display in the output:
    1. Select the Display tab.
    2. Select the following columns:
      • Id
      • Email

        Note: A default list of columns displays when you select the Display tab. Deselect the columns you do not need. If a column you need is not in the default list, select All from the View drop-down list and scroll down the page to select the desired column.

    3. Using the Order drop-down list, assign:
      • Id Order 1
      • Email Order 2
  7. Specify the sorting priority:
    1. Select the Sorting tab.
    2. Sort the results by Id.
    3. Add your selection.
  8. Save your settings.
  9. Run the query.

See Also

Query Examples

Example: Find current registrants

Example: Find registered members by city

Example: Find members by company and state

Example: Find purchases by amount and date

Example: Find members by state or join date

Example: Find total number of pledges by amount


ASI logo 10.6 Production Release. Updated 7/27/2006 3:53:06 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.